﻿CREATE TABLE [dbo].[NonXMLContent] (
    [MIMEType]                  VARCHAR (100)    NULL,
    [Size]                      INT              NOT NULL,
    [Digest]                    VARCHAR (500)    NULL,
    [Uri]                       VARCHAR (500)    NULL,
    [BinaryContentData]         VARBINARY (MAX)  NULL,
    [BinaryContentID]           UNIQUEIDENTIFIER DEFAULT (newid()) ROWGUIDCOL NOT NULL,
    [Id]                        INT              IDENTITY (1, 1) NOT NULL,
    [EmergencyMessageContentId] INT              NOT NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Non-XML MIME type message content', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The content type and sub-type as described in [RFC 2046] (e.g., application/pdf, application/mp3)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'MIMEType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Size of the content', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'Size';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Digest value of the content calculated using the Secure Hash Algorithm (SHA-1)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'Digest';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'A Unifrom Resource Identifier that can be used to retrieve the identified resource. A Uniform Resource Locator that can be used to retrieve the resource over the Internet or a relative URI naming a file.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'Uri';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Encoded content using base-64', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'BinaryContentData';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Unique identifier generated by the database management system.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'Id';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Reference to the associated message content.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NonXMLContent', @level2type = N'COLUMN', @level2name = N'EmergencyMessageContentId';

